package com.ruoyi.system.mapper;

import com.ruoyi.system.domain.Projects;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * projectsMapper接口
 * 
 * @author ruoyi
 * @date 2025-08-05
 */
public interface ProjectsMapper 
{
    Object getMaxNumber();

    List<Projects> selectValid(@Param("projectname") String ppprojectname,@Param("projecttype") String ppprojecttype,@Param("fabushijian") String ppfabushijian,@Param("publishingunit") String pppublishingunit,@Param("paixu") String pppaixu, @Param("startindex") int ppStartIndex, @Param("pagesize") int ppPageSize);

    Object countValid(@Param("projectname") String ppprojectname,@Param("projecttype") String ppprojecttype,@Param("fabushijian") String ppfabushijian,@Param("publishingunit") String pppublishingunit);

    List<Projects> selectAll(@Param("projectname") String ppprojectname,@Param("projecttype") String ppprojecttype, @Param("startindex") int ppStartIndex, @Param("pagesize") int ppPageSize);

    Object countAll(@Param("projectname") String ppprojectname,@Param("projecttype") String ppprojecttype);
    /**
     * 查询projects
     * 
     * @param id projects主键
     * @return projects
     */
    public Projects selectProjectsById(String id);

    /**
     * 查询projects列表
     * 
     * @param projects projects
     * @return projects集合
     */
    public List<Projects> selectProjectsList(Projects projects);

    /**
     * 新增projects
     * 
     * @param projects projects
     * @return 结果
     */
    public int insertProjects(Projects projects);

    /**
     * 修改projects
     * 
     * @param projects projects
     * @return 结果
     */
    public int updateProjects(Projects projects);

    /**
     * 删除projects
     * 
     * @param id projects主键
     * @return 结果
     */
    public int deleteProjectsById(String id);

    /**
     * 批量删除projects
     * 
     * @param ids 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteProjectsByIds(String[] ids);
}
